Basic PostgreSQL query statements
report_sample=# select datname from pg_database; +---------------+ | datname | +---------------+ | template1 | | template0 | | postgres | | report_sample | | report_backup | +---------------+ 5 rows in set (0.01 sec) report_sample=# select tablename from pg_tables; +-------------------------+ | tablename | +-------------------------+ | customer | | clients | | items | | orders | | parts | | plbiolife | +-------------------------+ 6 rows in set (0.02 sec) report_sample=# select "Description", "Cost" from public.parts where "PartNo" = 2619; +--------------------+-------+ | Description | Cost | +--------------------+-------+ | Navigation Compass | 9.177 | +--------------------+-------+ 1 row in set (0.03 sec) report_sample=#